Tables Ribbon

The ribbon in the Tables panel exposes several useful functions.

  • Data Catalog: use this to upload or download the entire data catalog as a file for the current model.

General

Model

  • Data Catalog: download or upload the data catalog details (JSON file format)
  • Disable Cache: disable query caching for the model.
  • Sync Schema: sync the schema diagram with the latest changes in the underlying database

Tables

The 'Tables' functions relate to the behavior of the data model.

  • Add a Query: construct an SQL or SOQL script create a custom table when direct querying has been enabled.
  • Auto Index: enable or disable auto indexing on the model.
  • Auto Relationship: choose the algorithm that should be used to define the relationships (joins) in the model.
  • Clear Relationships: choose the type of relationships to be cleared
  • Add New Relationships: add a new relationship between two tables
  • Validate Joins: ensure the join relationships are valid
  •  

Diagram

The 'Diagram' functions are used to change the look and feel of the Tables diagram.

  • Editor View: switches the view from diagram mode to a table view of all the relationships. Editor View can make it easier to identify and edit relationships in large models.
  • Rearrange: click to rearrange the tables into their original positions (after moving them).
  • Scale to Fit: scale the diagram down to fit the canvas.
  • Expand All: expand all tables so that their columns can be viewed.
  • Collapse All: collapse all tables so their columns are not visible.
  • Connector Type: select the type of line that will connect joined tables. The default connector type is 'path', but can be changed to 'direct' (straight lines).
  • Show All Tables: show all tables in the model, including hidden tables.
  • Aggregate Tables: open dialogue to show which tables are assigned as Aggregate Tables. You can also set tables to be of aggregate type here if there are many to set. This is easier than setting them individually through the table properties panel.
  • Attribute Options: selects which attribute properties are shown in the table header.

    • Primary Key: show or hide the primary key icon for columns manually set as primary keys.

    • Hidden Columns: show or hide hidden columns.

    • Column Type: show or hide the column type icons for each column.

    • Columns Index: show or hide the index icon for columns manually set as index columns.

  • Delete: delete a selected relationship; only enabled when a relationship is clicked on.

Schedule

Discovery